UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KI1GjriY8UwYbib1hSJoy83klnwvHEeGjwbxhstX6NY='
WHERE
key_id = 'f72626c5b39fdda33f802ef323c7353f4848595254e25ea4fe40011db16d8d4b'
AND (
token = 'KI1GjriY8UwYbib1hSJoy83klnwvHEeGjwbxhstX6NY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)