UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQha3V7BI6d3eNN1c/ksZ09/Jxs2VRz4g2Qe50YukJA='
WHERE
key_id = 'ccc96ad26db4b96d5b1f4c623a9588d639c9d37883b67d7bff9a7e39a2bb89f2'
AND (
token = 'xQha3V7BI6d3eNN1c/ksZ09/Jxs2VRz4g2Qe50YukJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)