UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNJW3SdniljQ9aiqhGoLJJcZl9b09jTWzYMS3M91k+4='
WHERE
key_id = '8a9f4599a2973caa355673595f759c582978d40d2b8b152200a2955afcb6dc54'
AND (
token = 'gNJW3SdniljQ9aiqhGoLJJcZl9b09jTWzYMS3M91k+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)