UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z3Dcmr1LoAuKyX248hUOpmkWl5XnAA0l5dWrdL3M0MQ='
WHERE
key_id = '1e8e4a6ee4cf5db44f2b9aed0639191fc0f39d40159be2a6a210e679de71bfac'
AND (
token = 'z3Dcmr1LoAuKyX248hUOpmkWl5XnAA0l5dWrdL3M0MQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)