UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lWd+KHoHW3cuSD4AvsI1m4oApsV0krB+25dgBhrwFJs='
WHERE
key_id = 'fd84d08fdd14ed419a834ac058dc4f26f392f601809431be6b7e6e6a0b9a202e'
AND (
token = 'lWd+KHoHW3cuSD4AvsI1m4oApsV0krB+25dgBhrwFJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)