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