UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHDoJd9BumS1jipCWM4I3r7ID3UiKV9YlAAzvUu3wpk='
WHERE
key_id = 'c239fd30270168d101877655f2446f531c8b4022a25f6df6acbe1352040baffa'
AND (
token = 'zHDoJd9BumS1jipCWM4I3r7ID3UiKV9YlAAzvUu3wpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)