UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8mX8qaRgWiUiqPFNOJSHwYE6UFPyUQX5Kp2YxPS+iI='
WHERE
key_id = 'b12fde705656fb5f7e19319ff185a4ccdbbe8617e4d172ec0d76302395ebe799'
AND (
token = 'R8mX8qaRgWiUiqPFNOJSHwYE6UFPyUQX5Kp2YxPS+iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)