UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tM2pL7Rr9Vi2JgHxEOgOOD6scQHN6mPKH5X/9A+33IA='
WHERE
key_id = '9e5238e9d359e66095e78820cee0cafd085a4681ccba505819fd6c4509c1f7ae'
AND (
token = 'tM2pL7Rr9Vi2JgHxEOgOOD6scQHN6mPKH5X/9A+33IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)