UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLBNz7/bHqgKQDl0UeA+DIyzDzu0zNfP3mEhSeJO4L0='
WHERE
key_id = '46972b2b0040cc43ae77198a391069e65c7140aa29b7476ae286360cd0abea3d'
AND (
token = 'nLBNz7/bHqgKQDl0UeA+DIyzDzu0zNfP3mEhSeJO4L0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)