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