UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oL9JR1/mYa1q/n9SZD97dt4jxUde+8sjCWafI/4KOBU='
WHERE
key_id = 'c5f5a82f9b12d10ce934b49cf9ab3c19ad0a05116e167e54cc3cba107eedc531'
AND (
token = 'oL9JR1/mYa1q/n9SZD97dt4jxUde+8sjCWafI/4KOBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)