UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4/6zASQUH3N+dRrVpzpO+1HaWRKWik/cMd+g43EHlA='
WHERE
key_id = '2405f2716e3182caa78d5079a3fa334cef0ab80acf144005c520fd7184bd72a8'
AND (
token = 'A4/6zASQUH3N+dRrVpzpO+1HaWRKWik/cMd+g43EHlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)