UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8cyIzogwGlxM1K9HZTqUM55sdmNS+S3m0cs+CG7Vep0='
WHERE
key_id = '1391b01f1d21d24a89a6cd9930ccd2e37d895a341a540adf105f2bb3ff75b72b'
AND (
token = '8cyIzogwGlxM1K9HZTqUM55sdmNS+S3m0cs+CG7Vep0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)