UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Ym7VYPtldmALFQlOeJBolY0xkz0wjuOgJr1DXXSmTk='
WHERE
key_id = 'e7912251329e4ce1e95fad6a717053f7e28a17ba930b21817a44b688249bc8f2'
AND (
token = '7Ym7VYPtldmALFQlOeJBolY0xkz0wjuOgJr1DXXSmTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)