UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8PrLrpyvaefnBLdGCh2pJY728FbTpCgH4Zckhl0Zdn8='
WHERE
key_id = '1d567f062a7b3fc989f1a0b7fc39142abdf5f4d590d65d12ff2c548df4719469'
AND (
token = '8PrLrpyvaefnBLdGCh2pJY728FbTpCgH4Zckhl0Zdn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)