UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wEAieFijf8xEsxdNSK2RFKguN3Fds3/CmSVaEmXJYwU='
WHERE
key_id = '57a8717ce324ae5e8c43bc1eeec67e0fa7c8c20b0d7c7a308dd2f5f87124b6ae'
AND (
token = 'wEAieFijf8xEsxdNSK2RFKguN3Fds3/CmSVaEmXJYwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)