UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yVjNhNuCwe0J87EW7vuB277MR0cNrSNnm5L78G+gSNA='
WHERE
key_id = '00b16424a2f3f6804cc12f817e06b2037318701365be60ab4032e1137160fc09'
AND (
token = 'yVjNhNuCwe0J87EW7vuB277MR0cNrSNnm5L78G+gSNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)