UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xoK5RGsMVghgHoQPbUd4mdhRMmsGjW3y9Y3Gr/L7vZM='
WHERE
key_id = 'c2181fe6b878b1fba0f55a3e9f9f5e51a4dc5b3b96492c183f1e539a006a70f6'
AND (
token = 'xoK5RGsMVghgHoQPbUd4mdhRMmsGjW3y9Y3Gr/L7vZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)