UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lc7o2Sorn6F+9mHgb9OUs9NB8DAhxtKkmn9UU8QVhho='
WHERE
key_id = '123fa3b2dcb88d0cc0685f96f1bc32d6b8a5b67daf210b7f32cf15db04b7a1d2'
AND (
token = 'Lc7o2Sorn6F+9mHgb9OUs9NB8DAhxtKkmn9UU8QVhho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)