UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfdHAoBfRzc51r6DSLRm0+pWjeLXlrdGTqWABB+4qhU='
WHERE
key_id = 'd10d61b0065077e8320643b3ac674f2705e41b3a220918df316eac3bf27da3a5'
AND (
token = 'pfdHAoBfRzc51r6DSLRm0+pWjeLXlrdGTqWABB+4qhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)