UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dVgAms8Jx/ddeIc3UoESmaPIp3HByQX6oqSiR+lABWk='
WHERE
key_id = 'c1d2f9286b189eee65d37c9882702a1a4b764da49bbd9b1561fb825d4a20aaa9'
AND (
token = 'dVgAms8Jx/ddeIc3UoESmaPIp3HByQX6oqSiR+lABWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)