UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1ZksLf3pu6e6fs13u6J0NgCwvHKDqkADc0B3eqL2HQ='
WHERE
key_id = '7ec995e4c3ee105a52a56c3ae8c4710ca40112d31d207d21fd5b68dd755cd86c'
AND (
token = 'J1ZksLf3pu6e6fs13u6J0NgCwvHKDqkADc0B3eqL2HQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)