UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QpwtjK5BeHt6Z5MiS8aYakeoALu1LAX4gU12xyZbwFo='
WHERE
key_id = '079c27ee71d55b5ed05dedba456dcb68753a9a45bc21d24c12611e7031ba3aeb'
AND (
token = 'QpwtjK5BeHt6Z5MiS8aYakeoALu1LAX4gU12xyZbwFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)