UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sC6MT63zW+h8BxiS8CbO1p0wl/rEIx2RNAvTP3GYME='
WHERE
key_id = 'b9c13a39dea59cd5f00e67743265805ec7337897bae87c9913b1f5075994f07b'
AND (
token = '7sC6MT63zW+h8BxiS8CbO1p0wl/rEIx2RNAvTP3GYME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)