UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wV31sAVBhUwJ2Hx5gHfCJACi6976DLvaIAQyXfd5NbA='
WHERE
key_id = '49585e46bc2a08c6d5709fea66e27a95fd6aa508a519e5e195e1cfa4e5dd67ba'
AND (
token = 'wV31sAVBhUwJ2Hx5gHfCJACi6976DLvaIAQyXfd5NbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)