UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HidZHv4aYOcTuz7N9EtY0hz2bwuTb2juQPRxF9rn8os='
WHERE
key_id = '20c34cbfaaed56b75060ba97d8eefe94f85cc46c20a3c17ca47fa4cac810b088'
AND (
token = 'HidZHv4aYOcTuz7N9EtY0hz2bwuTb2juQPRxF9rn8os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)