UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2KqErr2kEmXxldbHuCBrXUSBrOgheBVcZUHDkelI8HU='
WHERE
key_id = '516e3acc252a0eb75cf64907d3d6e4b129f3ef594f39cc46e1d5e6e1f8247114'
AND (
token = '2KqErr2kEmXxldbHuCBrXUSBrOgheBVcZUHDkelI8HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)