UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzZtnDwIJrJwBDmhD4yNNPbiXQy12OzJTROuV0q+3xQ='
WHERE
key_id = '007adb9fbb8f8dbd2589c047713ece1149d95123f290a3c3d9d85777a00dc1cb'
AND (
token = 'DzZtnDwIJrJwBDmhD4yNNPbiXQy12OzJTROuV0q+3xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)