UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIhCyHR1+IgE/y/e/Pzzo9bHePCprmKTCyG3eowBNzI='
WHERE
key_id = 'b0ba7d0b93b6434a77222762229960e3dcc140aeba3b446ca512873989985654'
AND (
token = 'mIhCyHR1+IgE/y/e/Pzzo9bHePCprmKTCyG3eowBNzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)