UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpaLTj9jvzBzDQ2ML1kRbOXnMqEGc3sXfgYf10XxqAA='
WHERE
key_id = '878a75c3949d49ecd1dccc7b24b3799a4cbf10e67dfbbeabbe037378066c1dd5'
AND (
token = 'ZpaLTj9jvzBzDQ2ML1kRbOXnMqEGc3sXfgYf10XxqAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)