UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgqnFblPgHGko4jQ3QDBxzgsrFs9ImQ8b1MmRWy2y6E='
WHERE
key_id = 'c0acf4fb0b9154ab7db99bfbf8e39cb11b2dd0e493dbd689f48b220a4ef4df74'
AND (
token = 'KgqnFblPgHGko4jQ3QDBxzgsrFs9ImQ8b1MmRWy2y6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)