UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P+c+usZyw13BapzsWYfe7Ue8ZqXMkhfOuw79p9YkOeA='
WHERE
key_id = '254b0a02e0a08ea57f8f93444a5b97de7f44a464b78d8bc389d8e73166d56ec0'
AND (
token = 'P+c+usZyw13BapzsWYfe7Ue8ZqXMkhfOuw79p9YkOeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)