UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8mfghaU/VIwx6JsydegAOLrIuSMc9wmZ5q1R/q21ig='
WHERE
key_id = 'bd8c5191a5189918ab342d75e6c54bdcb71b9d3ce9ec4358c14f4b8772d23b2e'
AND (
token = 'w8mfghaU/VIwx6JsydegAOLrIuSMc9wmZ5q1R/q21ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)