UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bnOfYWcGuWRqY2FP3RIEwKmVcDKr664EQmbGJtMsgk='
WHERE
key_id = '04ae32939239cdba87ffa42f5e5aa6615c32b9f64dfc4f8495f37efad1f1b21f'
AND (
token = '7bnOfYWcGuWRqY2FP3RIEwKmVcDKr664EQmbGJtMsgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)