UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUyiSNXkn+niB1IiRPBaA5tPtAvr0zj64137ZIBrbvA='
WHERE
key_id = 'c69f4972267a984f0be39e8df40aa1444ef7ccbdc1c07092f363aa0460e3a59a'
AND (
token = 'CUyiSNXkn+niB1IiRPBaA5tPtAvr0zj64137ZIBrbvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)