UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qtwsNVYggNTyHqsx90Qb7sdxgGOWdsCBTXL/+U6T9P0='
WHERE
key_id = '1382a9197b3d3fa22a426626554a66b356e7c2be2da7462b36b882902ae33f71'
AND (
token = 'qtwsNVYggNTyHqsx90Qb7sdxgGOWdsCBTXL/+U6T9P0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)